Pandas Profiling Report

Dataset statistics

Number of variables	49
Number of observations	49847
Missing cells	41116
Missing cells (%)	1.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	111.3 MiB
Average record size in memory	2.3 KiB

Variable types

Numeric	12
Categorical	23
Boolean	14

Alerts

`ANALYTES` has constant value "B"	Constant
`HOUSE_NUM` has a high cardinality: 1571 distinct values	High cardinality
`STREET_NAME` has a high cardinality: 4107 distinct values	High cardinality
`CONFIRMATION_NUM` has a high cardinality: 41010 distinct values	High cardinality
`INSPECTION_BY_FIRM` has a high cardinality: 700 distinct values	High cardinality
`INSPECTION_DATE` has a high cardinality: 3116 distinct values	High cardinality
`LAB_NAME` has a high cardinality: 738 distinct values	High cardinality
`NTA` has a high cardinality: 147 distinct values	High cardinality
`BIN` is highly correlated with `ZIP` and 3 other fields	High correlation
`ZIP` is highly correlated with `BOROUGH` and 6 other fields	High correlation
`BLOCK` is highly correlated with `BOROUGH` and 7 other fields	High correlation
`LOT` is highly correlated with `ANALYTES`	High correlation
`REPORTING_YEAR` is highly correlated with `BATCH_DATE`	High correlation
`TANK_NUM` is highly correlated with `ANALYTES`	High correlation
`LATITUDE` is highly correlated with `BOROUGH` and 7 other fields	High correlation
`LONGITUDE` is highly correlated with `BOROUGH` and 7 other fields	High correlation
`COMMUNITY_BOARD` is highly correlated with `BLOCK` and 3 other fields	High correlation
`COUNCIL_DISTRICT` is highly correlated with `BOROUGH` and 7 other fields	High correlation
`CENSUS_TRACT` is highly correlated with `ZIP` and 4 other fields	High correlation
`BBL` is highly correlated with `BOROUGH` and 8 other fields	High correlation
`BOROUGH` is highly correlated with `ZIP` and 5 other fields	High correlation
`INSPECTION_PERFORMED` is highly correlated with `GI_REQ_INTERNAL_STRUCTURE` and 9 other fields	High correlation
`GI_REQ_INTERNAL_STRUCTURE` is highly correlated with `INSPECTION_PERFORMED` and 9 other fields	High correlation
`GI_RESULT_INTERNAL_STRUCTURE` is highly correlated with `GI_RESULT_EXTERNAL_STRUCTURE` and 3 other fields	High correlation
`GI_REQ_EXTERNAL_STRUCTURE` is highly correlated with `INSPECTION_PERFORMED` and 9 other fields	High correlation
`GI_RESULT_EXTERNAL_STRUCTURE` is highly correlated with `GI_RESULT_INTERNAL_STRUCTURE` and 5 other fields	High correlation
`GI_REQ_OVERFLOW_PIPES` is highly correlated with `INSPECTION_PERFORMED` and 9 other fields	High correlation
`GI_RESULT_OVERFLOW_PIPES` is highly correlated with `GI_RESULT_EXTERNAL_STRUCTURE` and 2 other fields	High correlation
`GI_REQ_ACCESS_LADDERS` is highly correlated with `INSPECTION_PERFORMED` and 9 other fields	High correlation
`GI_RESULT_ACCESS_LADDERS` is highly correlated with `GI_RESULT_INTERNAL_STRUCTURE` and 4 other fields	High correlation
`GI_REQ_AIR_VENTS` is highly correlated with `INSPECTION_PERFORMED` and 9 other fields	High correlation
`GI_RESULT_AIR_VENTS` is highly correlated with `GI_RESULT_INTERNAL_STRUCTURE` and 3 other fields	High correlation
`GI_REQ_ROOF_ACCESS` is highly correlated with `INSPECTION_PERFORMED` and 9 other fields	High correlation
`GI_RESULT_ROOF_ACCESS` is highly correlated with `GI_RESULT_EXTERNAL_STRUCTURE` and 1 other fields	High correlation
`SI_REQ_SEDIMENT` is highly correlated with `INSPECTION_PERFORMED` and 9 other fields	High correlation
`SI_RESULT_SEDIMENT` is highly correlated with `SI_RESULT_DEBRIS_INSECTS`	High correlation
`SI_REQ_BIOLOGICAL_GROWTH` is highly correlated with `INSPECTION_PERFORMED` and 9 other fields	High correlation
`SI_RESULT_BIOLOGICAL_GROWTH` is highly correlated with `SI_RESULT_DEBRIS_INSECTS` and 1 other fields	High correlation
`SI_REQ_DEBRIS_INSECTS` is highly correlated with `INSPECTION_PERFORMED` and 9 other fields	High correlation
`SI_RESULT_DEBRIS_INSECTS` is highly correlated with `SI_RESULT_SEDIMENT` and 1 other fields	High correlation
`SI_REQ_RODENT_BIRD` is highly correlated with `INSPECTION_PERFORMED` and 9 other fields	High correlation
`SI_RESULT_RODENT_BIRD` is highly correlated with `SI_RESULT_BIOLOGICAL_GROWTH` and 1 other fields	High correlation
`SAMPLE_COLLECTED` is highly correlated with `ECOLI` and 4 other fields	High correlation
`NYS_CERTIFIED` is highly correlated with `MEET_STANDARDS`	High correlation
`ANALYTES` is highly correlated with `ECOLI` and 28 other fields	High correlation
`COLIFORM` is highly correlated with `ECOLI`	High correlation
`ECOLI` is highly correlated with `COLIFORM` and 1 other fields	High correlation
`MEET_STANDARDS` is highly correlated with `GI_RESULT_INTERNAL_STRUCTURE` and 5 other fields	High correlation
`DELETED` is highly correlated with `MEET_STANDARDS` and 3 other fields	High correlation
`BATCH_DATE` is highly correlated with `REPORTING_YEAR`	High correlation
`MEET_STANDARDS` has 38723 (77.7%) missing values	Missing
`BIN` is highly skewed (γ1 = 32.81932176)	Skewed
`CONFIRMATION_NUM` is uniformly distributed	Uniform

Reproduction

Analysis started	2024-05-07 19:20:48.568146
Analysis finished	2024-05-07 19:21:48.177178
Duration	59.61 seconds
Software version	pandas-profiling v3.4.0
Download configuration	config.json

BIN
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED

Distinct	5559
Distinct (%)	11.2%
Missing	112
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	4251135.238

Minimum	1000000
Maximum	4050200001
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.6 KiB

Quantile statistics

Minimum	1000000
5-th percentile	1002348
Q1	1020194
median	1041701
Q3	1082759
95-th percentile	3348849
Maximum	4050200001
Range	4049200001
Interquartile range (IQR)	62565

Descriptive statistics

Standard deviation	66882052.86
Coefficient of variation (CV)	15.73275116
Kurtosis	1433.246056
Mean	4251135.238
Median Absolute Deviation (MAD)	26118
Skewness	32.81932176
Sum	2.114302111 × 10¹¹
Variance	4.473208994 × 10¹⁵
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1084781	115	0.2%
1083346	100	0.2%
1071414	90	0.2%
1026318	80	0.2%
1001394	79	0.2%
1015862	71	0.1%
1001227	70	0.1%
1001025	69	0.1%
1000000	68	0.1%
1085735	59	0.1%
Other values (5549)	48934	98.2%
(Missing)	112	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1000000	68	0.1%
1000005	32	0.1%
1000006	22	< 0.1%
1000007	16	< 0.1%
1000018	9	< 0.1%
1000020	19	< 0.1%
1000021	30	0.1%
1000023	9	< 0.1%
1000025	21	< 0.1%
1000027	8	< 0.1%

Value	Count	Frequency (%)
4050200001	1	< 0.1%
4020860040	1	< 0.1%
4002680001	1	< 0.1%
3065080006	1	< 0.1%
3036210001	1	< 0.1%
3019020001	1	< 0.1%
3012830001	1	< 0.1%
3010720040	1	< 0.1%
3001220010	1	< 0.1%
2043470007	1	< 0.1%

BOROUGH
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.1 MiB

MANHATTAN	42593
BROOKLYN	2925
BRONX	2291
QUEENS	1962
STATEN ISLAND	76

Length

Max length	13
Median length	9
Mean length	8.645495215
Min length	5

Characters and Unicode

Total characters	430952
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MANHATTAN
2nd row	MANHATTAN
3rd row	BRONX
4th row	MANHATTAN
5th row	QUEENS

Common Values

Value	Count	Frequency (%)
MANHATTAN	42593	85.4%
BROOKLYN	2925	5.9%
BRONX	2291	4.6%
QUEENS	1962	3.9%
STATEN ISLAND	76	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
manhattan	42593	85.3%
brooklyn	2925	5.9%
bronx	2291	4.6%
queens	1962	3.9%
staten	76	0.2%
island	76	0.2%

Most occurring characters

Value	Count	Frequency (%)
A	127931	29.7%
N	92516	21.5%
T	85338	19.8%
M	42593	9.9%
H	42593	9.9%
O	8141	1.9%
B	5216	1.2%
R	5216	1.2%
E	4000	0.9%
L	3001	0.7%
Other values (9)	14407	3.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	430876	> 99.9%
Space Separator	76	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	127931	29.7%
N	92516	21.5%
T	85338	19.8%
M	42593	9.9%
H	42593	9.9%
O	8141	1.9%
B	5216	1.2%
R	5216	1.2%
E	4000	0.9%
L	3001	0.7%
Other values (8)	14331	3.3%

Space Separator

Value	Count	Frequency (%)
	76	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	430876	> 99.9%
Common	76	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	127931	29.7%
N	92516	21.5%
T	85338	19.8%
M	42593	9.9%
H	42593	9.9%
O	8141	1.9%
B	5216	1.2%
R	5216	1.2%
E	4000	0.9%
L	3001	0.7%
Other values (8)	14331	3.3%

Common

Value	Count	Frequency (%)
	76	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	430952	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	127931	29.7%
N	92516	21.5%
T	85338	19.8%
M	42593	9.9%
H	42593	9.9%
O	8141	1.9%
B	5216	1.2%
R	5216	1.2%
E	4000	0.9%
L	3001	0.7%
Other values (9)	14407	3.3%

ZIP
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	177
Distinct (%)	0.4%
Missing	71
Missing (%)	0.1%
Infinite	0
Infinite (%)	0.0%
Mean	10170.86674

Minimum	10001
Maximum	11694
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.6 KiB

Quantile statistics

Minimum	10001
5-th percentile	10002
Q1	10016
median	10022
Q3	10065
95-th percentile	11217
Maximum	11694
Range	1693
Interquartile range (IQR)	49

Descriptive statistics

Standard deviation	373.8736833
Coefficient of variation (CV)	0.03675927457
Kurtosis	4.615142951
Mean	10170.86674
Median Absolute Deviation (MAD)	11
Skewness	2.479114903
Sum	506265063
Variance	139781.531
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10022	2919	5.9%
10016	2713	5.4%
10019	2237	4.5%
10001	2147	4.3%
10017	1994	4.0%
10024	1971	4.0%
10003	1911	3.8%
10036	1888	3.8%
10025	1863	3.7%
10023	1834	3.7%
Other values (167)	28299	56.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10001	2147	4.3%
10002	411	0.8%
10003	1911	3.8%
10004	589	1.2%
10005	517	1.0%
10006	279	0.6%
10007	746	1.5%
10009	174	0.3%
10010	1453	2.9%
10011	1623	3.3%

Value	Count	Frequency (%)
11694	26	0.1%
11692	23	< 0.1%
11691	55	0.1%
11435	20	< 0.1%
11434	36	0.1%
11433	13	< 0.1%
11432	175	0.4%
11421	6	< 0.1%
11418	25	0.1%
11415	53	0.1%

HOUSE_NUM
Categorical

HIGH CARDINALITY

Distinct	1571
Distinct (%)	3.2%
Missing	0
Missing (%)	0.0%
Memory size	2.8 MiB

1	791
200	666
10	515
300	437
50	420
Other values (1566)	47018

Length

Max length	9
Median length	3
Mean length	2.918951993
Min length	1

Characters and Unicode

Total characters	145501
Distinct characters	29
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	96 ?
Unique (%)	0.2%

Sample

1st row	405
2nd row	131
3rd row	1118
4th row	28
5th row	30-30

Common Values

Value	Count	Frequency (%)
1	791	1.6%
200	666	1.3%
10	515	1.0%
300	437	0.9%
50	420	0.8%
40	409	0.8%
55	389	0.8%
150	383	0.8%
2	372	0.7%
30	369	0.7%
Other values (1561)	45096	90.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1	791	1.6%
200	666	1.3%
10	515	1.0%
300	437	0.9%
50	420	0.8%
40	409	0.8%
55	389	0.8%
150	383	0.8%
2	372	0.7%
30	369	0.7%
Other values (1558)	45096	90.5%

Most occurring characters

Value	Count	Frequency (%)
1	26537	18.2%
0	23184	15.9%
5	19414	13.3%
2	18048	12.4%
3	15185	10.4%
4	12770	8.8%
6	8462	5.8%
7	7400	5.1%
9	6065	4.2%
8	6024	4.1%
Other values (19)	2412	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	143089	98.3%
Dash Punctuation	2282	1.6%
Lowercase Letter	72	< 0.1%
Uppercase Letter	58	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	26537	18.5%
0	23184	16.2%
5	19414	13.6%
2	18048	12.6%
3	15185	10.6%
4	12770	8.9%
6	8462	5.9%
7	7400	5.2%
9	6065	4.2%
8	6024	4.2%

Lowercase Letter

Value	Count	Frequency (%)
e	21	29.2%
n	12	16.7%
a	9	12.5%
s	9	12.5%
t	9	12.5%
w	7	9.7%
i	2	2.8%
r	2	2.8%
b	1	1.4%

Uppercase Letter

Value	Count	Frequency (%)
A	16	27.6%
O	13	22.4%
S	10	17.2%
B	5	8.6%
D	4	6.9%
P	3	5.2%
E	3	5.2%
W	3	5.2%
N	1	1.7%

Dash Punctuation

Value	Count	Frequency (%)
-	2282	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	145371	99.9%
Latin	130	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	21	16.2%
A	16	12.3%
O	13	10.0%
n	12	9.2%
S	10	7.7%
a	9	6.9%
s	9	6.9%
t	9	6.9%
w	7	5.4%
B	5	3.8%
Other values (8)	19	14.6%

Common

Value	Count	Frequency (%)
1	26537	18.3%
0	23184	15.9%
5	19414	13.4%
2	18048	12.4%
3	15185	10.4%
4	12770	8.8%
6	8462	5.8%
7	7400	5.1%
9	6065	4.2%
8	6024	4.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	145501	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	26537	18.2%
0	23184	15.9%
5	19414	13.3%
2	18048	12.4%
3	15185	10.4%
4	12770	8.8%
6	8462	5.8%
7	7400	5.1%
9	6065	4.2%
8	6024	4.1%
Other values (19)	2412	1.7%

STREET_NAME
Categorical

HIGH CARDINALITY

Distinct	4107
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

Broadway	1389
PARK AVENUE	942
Park Avenue	905
Fifth Avenue	866
BROADWAY	730
Other values (4102)	45015

Length

Max length	28
Median length	26
Mean length	13.76594379
Min length	4

Characters and Unicode

Total characters	686191
Distinct characters	68
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1057 ?
Unique (%)	2.1%

Sample

1st row	LEXINGTON AVE
2nd row	East 66th Street
3rd row	grand concourse
4th row	EAST 10 STREET
5th row	47th Avenue

Common Values

Value	Count	Frequency (%)
Broadway	1389	2.8%
PARK AVENUE	942	1.9%
Park Avenue	905	1.8%
Fifth Avenue	866	1.7%
BROADWAY	730	1.5%
Madison Avenue	532	1.1%
WEST END AVENUE	471	0.9%
West End Avenue	471	0.9%
5 AVENUE	454	0.9%
FIFTH AVENUE	379	0.8%
Other values (4097)	42708	85.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
street	24782	20.0%
avenue	12199	9.8%
west	12082	9.8%
east	10421	8.4%
park	3389	2.7%
ave	2356	1.9%
st	2288	1.8%
broadway	2179	1.8%
fifth	1549	1.3%
end	1310	1.1%
Other values (1136)	51297	41.4%

Most occurring characters

Value	Count	Frequency (%)
	83157	12.1%
e	61299	8.9%
t	58805	8.6%
E	57077	8.3%
S	41256	6.0%
T	37915	5.5%
A	27948	4.1%
r	26045	3.8%
R	19477	2.8%
a	19317	2.8%
Other values (58)	253895	37.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	279606	40.7%
Uppercase Letter	273957	39.9%
Space Separator	83157	12.1%
Decimal Number	49129	7.2%
Other Punctuation	331	< 0.1%
Dash Punctuation	11	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	61299	21.9%
t	58805	21.0%
r	26045	9.3%
a	19317	6.9%
s	18538	6.6%
n	16142	5.8%
h	12990	4.6%
v	10630	3.8%
u	9599	3.4%
d	8406	3.0%
Other values (16)	37835	13.5%

Uppercase Letter

Value	Count	Frequency (%)
E	57077	20.8%
S	41256	15.1%
T	37915	13.8%
A	27948	10.2%
R	19477	7.1%
W	15030	5.5%
N	10687	3.9%
V	7658	2.8%
U	7241	2.6%
P	5984	2.2%
Other values (16)	43684	15.9%

Decimal Number

Value	Count	Frequency (%)
5	6237	12.7%
7	6134	12.5%
1	5549	11.3%
3	5515	11.2%
2	5345	10.9%
6	5043	10.3%
4	4942	10.1%
8	4495	9.1%
9	3440	7.0%
0	2429	4.9%

Other Punctuation

Value	Count	Frequency (%)
.	324	97.9%
,	4	1.2%
\	2	0.6%
'	1	0.3%

Space Separator

Value	Count	Frequency (%)
	83157	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	11	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	553563	80.7%
Common	132628	19.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	61299	11.1%
t	58805	10.6%
E	57077	10.3%
S	41256	7.5%
T	37915	6.8%
A	27948	5.0%
r	26045	4.7%
R	19477	3.5%
a	19317	3.5%
s	18538	3.3%
Other values (42)	185886	33.6%

Common

Value	Count	Frequency (%)
	83157	62.7%
5	6237	4.7%
7	6134	4.6%
1	5549	4.2%
3	5515	4.2%
2	5345	4.0%
6	5043	3.8%
4	4942	3.7%
8	4495	3.4%
9	3440	2.6%
Other values (6)	2771	2.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	686191	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	83157	12.1%
e	61299	8.9%
t	58805	8.6%
E	57077	8.3%
S	41256	6.0%
T	37915	5.5%
A	27948	4.1%
r	26045	3.8%
R	19477	2.8%
a	19317	2.8%
Other values (58)	253895	37.0%

BLOCK
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	1750
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1421.629266

Minimum	0
Maximum	20008
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	389.6 KiB

Quantile statistics

Minimum	0
5-th percentile	76
Q1	825
median	1215
Q3	1483
95-th percentile	3943
Maximum	20008
Range	20008
Interquartile range (IQR)	658

Descriptive statistics

Standard deviation	1478.282916
Coefficient of variation (CV)	1.039851213
Kurtosis	28.86119515
Mean	1421.629266
Median Absolute Deviation (MAD)	352
Skewness	4.454009872
Sum	70863954
Variance	2185320.38
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16	328	0.7%
1293	169	0.3%
838	166	0.3%
1261	164	0.3%
1263	157	0.3%
1171	142	0.3%
1290	142	0.3%
1289	136	0.3%
1480	136	0.3%
833	132	0.3%
Other values (1740)	48175	96.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	< 0.1%
1	11	< 0.1%
2	8	< 0.1%
4	32	0.1%
5	38	0.1%
6	26	0.1%
8	4	< 0.1%
9	58	0.1%
10	44	0.1%
11	40	0.1%

Value	Count	Frequency (%)
20008	1	< 0.1%
16177	26	0.1%
16083	9	< 0.1%
16001	14	< 0.1%
15955	18	< 0.1%
15810	17	< 0.1%
15638	13	< 0.1%
15610	5	< 0.1%
15537	2	< 0.1%
12495	36	0.1%

LOT
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	235
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1342.518085

Minimum	0
Maximum	9999
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	389.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	10
median	31
Q3	67
95-th percentile	7502
Maximum	9999
Range	9999
Interquartile range (IQR)	57

Descriptive statistics

Standard deviation	2847.860064
Coefficient of variation (CV)	2.121282458
Kurtosis	0.9580028125
Mean	1342.518085
Median Absolute Deviation (MAD)	26
Skewness	1.716657115
Sum	66920499
Variance	8110306.945
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	8150	16.4%
7501	5104	10.2%
7502	2031	4.1%
29	1004	2.0%
33	851	1.7%
20	847	1.7%
7503	801	1.6%
21	774	1.6%
5	774	1.6%
23	742	1.5%
Other values (225)	28769	57.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	< 0.1%
1	8150	16.4%
2	415	0.8%
3	425	0.9%
4	351	0.7%
5	774	1.6%
6	471	0.9%
7	606	1.2%
8	547	1.1%
9	490	1.0%

Value	Count	Frequency (%)
9999	1	< 0.1%
9100	10	< 0.1%
9080	6	< 0.1%
9078	9	< 0.1%
9062	2	< 0.1%
9059	8	< 0.1%
9029	3	< 0.1%
9024	8	< 0.1%
9021	7	< 0.1%
9020	9	< 0.1%

CONFIRMATION_NUM
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	41010
Distinct (%)	82.3%
Missing	0
Missing (%)	0.0%
Memory size	3.3 MiB

WTI4549961683	13
WTI2501915939	13
WTI0972981393	13
WTI4421642046	13
WTI3032892368	13
Other values (41005)	49782

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	648011
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	35150 ?
Unique (%)	70.5%

Sample

1st row	WTI0794137521
2nd row	WTI9605598636
3rd row	WTI2761355464
4th row	WTI5921313699
5th row	WTI5300059568

Common Values

Value	Count	Frequency (%)
WTI4549961683	13	< 0.1%
WTI2501915939	13	< 0.1%
WTI0972981393	13	< 0.1%
WTI4421642046	13	< 0.1%
WTI3032892368	13	< 0.1%
WTI8800012013	13	< 0.1%
WTI0949972830	13	< 0.1%
WTI8513845933	13	< 0.1%
WTI0312687900	13	< 0.1%
WTI3785983490	13	< 0.1%
Other values (41000)	49717	99.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
wti4549961683	13	< 0.1%
wti8513845933	13	< 0.1%
wti2501915939	13	< 0.1%
wti9332381256	13	< 0.1%
wti3785983490	13	< 0.1%
wti0312687900	13	< 0.1%
wti1503958526	13	< 0.1%
wti0949972830	13	< 0.1%
wti8800012013	13	< 0.1%
wti3032892368	13	< 0.1%
Other values (41000)	49717	99.7%

Most occurring characters

Value	Count	Frequency (%)
3	50262	7.8%
9	50196	7.7%
6	50140	7.7%
2	49993	7.7%
8	49878	7.7%
4	49875	7.7%
W	49847	7.7%
T	49847	7.7%
I	49847	7.7%
1	49805	7.7%
Other values (3)	148321	22.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	498470	76.9%
Uppercase Letter	149541	23.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	50262	10.1%
9	50196	10.1%
6	50140	10.1%
2	49993	10.0%
8	49878	10.0%
4	49875	10.0%
1	49805	10.0%
7	49622	10.0%
5	49433	9.9%
0	49266	9.9%

Uppercase Letter

Value	Count	Frequency (%)
W	49847	33.3%
T	49847	33.3%
I	49847	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	498470	76.9%
Latin	149541	23.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	50262	10.1%
9	50196	10.1%
6	50140	10.1%
2	49993	10.0%
8	49878	10.0%
4	49875	10.0%
1	49805	10.0%
7	49622	10.0%
5	49433	9.9%
0	49266	9.9%

Latin

Value	Count	Frequency (%)
W	49847	33.3%
T	49847	33.3%
I	49847	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	648011	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	50262	7.8%
9	50196	7.7%
6	50140	7.7%
2	49993	7.7%
8	49878	7.7%
4	49875	7.7%
W	49847	7.7%
T	49847	7.7%
I	49847	7.7%
1	49805	7.7%
Other values (3)	148321	22.9%

REPORTING_YEAR
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2019.294321

Minimum	2000
Maximum	2024
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.6 KiB

Quantile statistics

Minimum	2000
5-th percentile	2015
Q1	2017
median	2019
Q3	2021
95-th percentile	2023
Maximum	2024
Range	24
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.546163373
Coefficient of variation (CV)	0.001260917414
Kurtosis	-0.9346836283
Mean	2019.294321
Median Absolute Deviation (MAD)	2
Skewness	-0.1619628901
Sum	100655764
Variance	6.482947923
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
2020	6503	13.0%
2023	6012	12.1%
2022	5974	12.0%
2021	5887	11.8%
2019	5804	11.6%
2018	5541	11.1%
2017	4683	9.4%
2015	4584	9.2%
2016	4545	9.1%
2024	292	0.6%
Other values (3)	22	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2000	3	< 0.1%
2011	2	< 0.1%
2014	17	< 0.1%
2015	4584	9.2%
2016	4545	9.1%
2017	4683	9.4%
2018	5541	11.1%
2019	5804	11.6%
2020	6503	13.0%
2021	5887	11.8%

Value	Count	Frequency (%)
2024	292	0.6%
2023	6012	12.1%
2022	5974	12.0%
2021	5887	11.8%
2020	6503	13.0%
2019	5804	11.6%
2018	5541	11.1%
2017	4683	9.4%
2016	4545	9.1%
2015	4584	9.2%

TANK_NUM
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	13
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.304371376

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	3
Maximum	13
Range	12
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.8898090643
Coefficient of variation (CV)	0.6821746324
Kurtosis	37.62938186
Mean	1.304371376
Median Absolute Deviation (MAD)	0
Skewness	5.14079338
Sum	65019
Variance	0.7917601709
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
1	41010	82.3%
2	5860	11.8%
3	1528	3.1%
4	720	1.4%
5	267	0.5%
6	178	0.4%
7	104	0.2%
8	70	0.1%
9	41	0.1%
10	31	0.1%
Other values (3)	38	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	41010	82.3%
2	5860	11.8%
3	1528	3.1%
4	720	1.4%
5	267	0.5%
6	178	0.4%
7	104	0.2%
8	70	0.1%
9	41	0.1%
10	31	0.1%

Value	Count	Frequency (%)
13	12	< 0.1%
12	13	< 0.1%
11	13	< 0.1%
10	31	0.1%
9	41	0.1%
8	70	0.1%
7	104	0.2%
6	178	0.4%
5	267	0.5%
4	720	1.4%

INSPECTION_BY_FIRM
Categorical

HIGH CARDINALITY

Distinct	700
Distinct (%)	1.4%
Missing	22
Missing (%)	< 0.1%
Memory size	3.6 MiB

Rosenwach Tank Co. LLC	21887
ISSEKS BROS INC	8139
American Pipe and Tank	4010
Isseks Bros. Inc.	1764
isseks bros., inc.	1246
Other values (695)	12779

Length

Max length	69
Median length	22
Mean length	19.09890617
Min length	1

Characters and Unicode

Total characters	951603
Distinct characters	69
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	321 ?
Unique (%)	0.6%

Sample

1st row	ISSEKS BROS INC
2nd row	Rosenwach Tank Co. LLC
3rd row	DCAS
4th row	ISSEKS BROS INC
5th row	Rosenwach Tank Co. LLC

Common Values

Value	Count	Frequency (%)
Rosenwach Tank Co. LLC	21887	43.9%
ISSEKS BROS INC	8139	16.3%
American Pipe and Tank	4010	8.0%
Isseks Bros. Inc.	1764	3.5%
isseks bros., inc.	1246	2.5%
ISSEKS BROS., INC.	1028	2.1%
Isseks Bros Inc	935	1.9%
Isseks	834	1.7%
Atlantank, LLC	742	1.5%
Nalco	725	1.5%
Other values (690)	8515	17.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tank	28052	16.3%
llc	22969	13.4%
co	22163	12.9%
rosenwach	22002	12.8%
isseks	15781	9.2%
inc	15651	9.1%
bros	14673	8.5%
american	5962	3.5%
pipe	5946	3.5%
and	4524	2.6%
Other values (375)	14179	8.2%

Most occurring characters

Value	Count	Frequency (%)
	122149	12.8%
n	73678	7.7%
a	68481	7.2%
C	57938	6.1%
o	54592	5.7%
s	47002	4.9%
L	46723	4.9%
e	42537	4.5%
S	39039	4.1%
c	35610	3.7%
Other values (59)	363854	38.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	470220	49.4%
Uppercase Letter	319291	33.6%
Space Separator	122149	12.8%
Other Punctuation	39861	4.2%
Decimal Number	57	< 0.1%
Math Symbol	16	< 0.1%
Dash Punctuation	8	< 0.1%
Open Punctuation	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	57938	18.1%
L	46723	14.6%
S	39039	12.2%
R	32611	10.2%
I	30948	9.7%
T	28855	9.0%
B	14013	4.4%
N	13504	4.2%
E	11531	3.6%
K	10471	3.3%
Other values (16)	33658	10.5%

Lowercase Letter

Value	Count	Frequency (%)
n	73678	15.7%
a	68481	14.6%
o	54592	11.6%
s	47002	10.0%
e	42537	9.0%
c	35610	7.6%
k	35239	7.5%
h	23502	5.0%
w	22294	4.7%
i	16667	3.5%
Other values (15)	50618	10.8%

Decimal Number

Value	Count	Frequency (%)
2	28	49.1%
0	11	19.3%
3	5	8.8%
5	3	5.3%
9	3	5.3%
8	3	5.3%
7	3	5.3%
1	1	1.8%

Other Punctuation

Value	Count	Frequency (%)
.	33211	83.3%
,	4876	12.2%
&	1729	4.3%
/	29	0.1%
@	15	< 0.1%
%	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	122149	100.0%

Math Symbol

Value	Count	Frequency (%)
+	16	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	8	100.0%

Open Punctuation

Value	Count	Frequency (%)
[	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	789511	83.0%
Common	162092	17.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	73678	9.3%
a	68481	8.7%
C	57938	7.3%
o	54592	6.9%
s	47002	6.0%
L	46723	5.9%
e	42537	5.4%
S	39039	4.9%
c	35610	4.5%
k	35239	4.5%
Other values (41)	288672	36.6%

Common

Value	Count	Frequency (%)
	122149	75.4%
.	33211	20.5%
,	4876	3.0%
&	1729	1.1%
/	29	< 0.1%
2	28	< 0.1%
+	16	< 0.1%
@	15	< 0.1%
0	11	< 0.1%
-	8	< 0.1%
Other values (8)	20	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	951603	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	122149	12.8%
n	73678	7.7%
a	68481	7.2%
C	57938	6.1%
o	54592	5.7%
s	47002	4.9%
L	46723	4.9%
e	42537	4.5%
S	39039	4.1%
c	35610	3.7%
Other values (59)	363854	38.2%

INSPECTION_PERFORMED
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

True	49822
False	25

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49822	99.9%
False	25	0.1%

INSPECTION_DATE
Categorical

HIGH CARDINALITY

Distinct	3116
Distinct (%)	6.3%
Missing	22
Missing (%)	< 0.1%
Memory size	3.2 MiB

12/30/2015	91
06/27/2020	81
06/11/2020	80
06/20/2020	79
10/28/2020	74
Other values (3111)	49420

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	498250
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	200 ?
Unique (%)	0.4%

Sample

1st row	08/08/2015
2nd row	10/12/2021
3rd row	12/19/2023
4th row	01/13/2015
5th row	07/18/2015

Common Values

Value	Count	Frequency (%)
12/30/2015	91	0.2%
06/27/2020	81	0.2%
06/11/2020	80	0.2%
06/20/2020	79	0.2%
10/28/2020	74	0.1%
06/09/2020	74	0.1%
12/27/2018	74	0.1%
06/13/2020	73	0.1%
12/19/2015	72	0.1%
12/05/2020	71	0.1%
Other values (3106)	49056	98.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
12/30/2015	91	0.2%
06/27/2020	81	0.2%
06/11/2020	80	0.2%
06/20/2020	79	0.2%
10/28/2020	74	0.1%
06/09/2020	74	0.1%
12/27/2018	74	0.1%
06/13/2020	73	0.1%
12/19/2015	72	0.1%
12/05/2020	71	0.1%
Other values (3106)	49056	98.5%

Most occurring characters

Value	Count	Frequency (%)
0	112587	22.6%
2	109520	22.0%
/	99650	20.0%
1	79418	15.9%
8	15947	3.2%
9	15604	3.1%
3	15574	3.1%
6	14906	3.0%
7	14461	2.9%
5	13195	2.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	398600	80.0%
Other Punctuation	99650	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	112587	28.2%
2	109520	27.5%
1	79418	19.9%
8	15947	4.0%
9	15604	3.9%
3	15574	3.9%
6	14906	3.7%
7	14461	3.6%
5	13195	3.3%
4	7388	1.9%

Other Punctuation

Value	Count	Frequency (%)
/	99650	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	498250	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	112587	22.6%
2	109520	22.0%
/	99650	20.0%
1	79418	15.9%
8	15947	3.2%
9	15604	3.1%
3	15574	3.1%
6	14906	3.0%
7	14461	2.9%
5	13195	2.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	498250	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	112587	22.6%
2	109520	22.0%
/	99650	20.0%
1	79418	15.9%
8	15947	3.2%
9	15604	3.1%
3	15574	3.1%
6	14906	3.0%
7	14461	2.9%
5	13195	2.6%

GI_REQ_INTERNAL_STRUCTURE
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

True	49755
False	92

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49755	99.8%
False	92	0.2%

GI_RESULT_INTERNAL_STRUCTURE
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	94
Missing (%)	0.2%
Memory size	2.8 MiB

N	49601
A	152

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49753
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	49601	99.5%
A	152	0.3%
(Missing)	94	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
n	49601	99.7%
a	152	0.3%

Most occurring characters

Value	Count	Frequency (%)
N	49601	99.7%
A	152	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49753	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	49601	99.7%
A	152	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49753	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	49601	99.7%
A	152	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49753	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	49601	99.7%
A	152	0.3%

GI_REQ_EXTERNAL_STRUCTURE
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

True	49791
False	56

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49791	99.9%
False	56	0.1%

GI_RESULT_EXTERNAL_STRUCTURE
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	58
Missing (%)	0.1%
Memory size	2.8 MiB

N	49661
A	128

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49789
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	49661	99.6%
A	128	0.3%
(Missing)	58	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
n	49661	99.7%
a	128	0.3%

Most occurring characters

Value	Count	Frequency (%)
N	49661	99.7%
A	128	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49789	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	49661	99.7%
A	128	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49789	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	49661	99.7%
A	128	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49789	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	49661	99.7%
A	128	0.3%

GI_REQ_OVERFLOW_PIPES
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

True	49790
False	57

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49790	99.9%
False	57	0.1%

GI_RESULT_OVERFLOW_PIPES
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	59
Missing (%)	0.1%
Memory size	2.8 MiB

N	49707
A	81

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49788
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	49707	99.7%
A	81	0.2%
(Missing)	59	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
n	49707	99.8%
a	81	0.2%

Most occurring characters

Value	Count	Frequency (%)
N	49707	99.8%
A	81	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49788	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	49707	99.8%
A	81	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49788	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	49707	99.8%
A	81	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49788	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	49707	99.8%
A	81	0.2%

GI_REQ_ACCESS_LADDERS
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

True	49743
False	104

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49743	99.8%
False	104	0.2%

GI_RESULT_ACCESS_LADDERS
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	106
Missing (%)	0.2%
Memory size	2.8 MiB

N	49597
A	144

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49741
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	49597	99.5%
A	144	0.3%
(Missing)	106	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
n	49597	99.7%
a	144	0.3%

Most occurring characters

Value	Count	Frequency (%)
N	49597	99.7%
A	144	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49741	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	49597	99.7%
A	144	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49741	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	49597	99.7%
A	144	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49741	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	49597	99.7%
A	144	0.3%

GI_REQ_AIR_VENTS
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

True	49795
False	52

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49795	99.9%
False	52	0.1%

GI_RESULT_AIR_VENTS
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	54
Missing (%)	0.1%
Memory size	2.8 MiB

N	49670
A	123

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49793
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	49670	99.6%
A	123	0.2%
(Missing)	54	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
n	49670	99.8%
a	123	0.2%

Most occurring characters

Value	Count	Frequency (%)
N	49670	99.8%
A	123	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49793	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	49670	99.8%
A	123	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49793	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	49670	99.8%
A	123	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49793	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	49670	99.8%
A	123	0.2%

GI_REQ_ROOF_ACCESS
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

True	49723
False	124

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49723	99.8%
False	124	0.2%

GI_RESULT_ROOF_ACCESS
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	126
Missing (%)	0.3%
Memory size	2.8 MiB

N	49579
A	142

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49721
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	49579	99.5%
A	142	0.3%
(Missing)	126	0.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
n	49579	99.7%
a	142	0.3%

Most occurring characters

Value	Count	Frequency (%)
N	49579	99.7%
A	142	0.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49721	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	49579	99.7%
A	142	0.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49721	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	49579	99.7%
A	142	0.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49721	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	49579	99.7%
A	142	0.3%

SI_REQ_SEDIMENT
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

True	49748
False	99

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49748	99.8%
False	99	0.2%

SI_RESULT_SEDIMENT
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	99
Missing (%)	0.2%
Memory size	2.8 MiB

N	48798
A	950

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49748
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	48798	97.9%
A	950	1.9%
(Missing)	99	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
n	48798	98.1%
a	950	1.9%

Most occurring characters

Value	Count	Frequency (%)
N	48798	98.1%
A	950	1.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49748	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	48798	98.1%
A	950	1.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49748	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	48798	98.1%
A	950	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49748	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	48798	98.1%
A	950	1.9%

SI_REQ_BIOLOGICAL_GROWTH
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

True	49747
False	100

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49747	99.8%
False	100	0.2%

SI_RESULT_BIOLOGICAL_GROWTH
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	100
Missing (%)	0.2%
Memory size	2.8 MiB

N	49658
A	89

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49747
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	49658	99.6%
A	89	0.2%
(Missing)	100	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
n	49658	99.8%
a	89	0.2%

Most occurring characters

Value	Count	Frequency (%)
N	49658	99.8%
A	89	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49747	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	49658	99.8%
A	89	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49747	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	49658	99.8%
A	89	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49747	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	49658	99.8%
A	89	0.2%

SI_REQ_DEBRIS_INSECTS
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

True	49746
False	101

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49746	99.8%
False	101	0.2%

SI_RESULT_DEBRIS_INSECTS
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	101
Missing (%)	0.2%
Memory size	2.8 MiB

N	49533
A	213

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49746
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	49533	99.4%
A	213	0.4%
(Missing)	101	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
n	49533	99.6%
a	213	0.4%

Most occurring characters

Value	Count	Frequency (%)
N	49533	99.6%
A	213	0.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49746	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	49533	99.6%
A	213	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49746	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	49533	99.6%
A	213	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49746	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	49533	99.6%
A	213	0.4%

SI_REQ_RODENT_BIRD
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

True	49785
False	62

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49785	99.9%
False	62	0.1%

SI_RESULT_RODENT_BIRD
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	62
Missing (%)	0.1%
Memory size	2.8 MiB

N	49743
A	42

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49785
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	N

Common Values

Value	Count	Frequency (%)
N	49743	99.8%
A	42	0.1%
(Missing)	62	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
n	49743	99.9%
a	42	0.1%

Most occurring characters

Value	Count	Frequency (%)
N	49743	99.9%
A	42	0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49785	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	49743	99.9%
A	42	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49785	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	49743	99.9%
A	42	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49785	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	49743	99.9%
A	42	0.1%

SAMPLE_COLLECTED
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	6
Missing (%)	< 0.1%
Memory size	97.5 KiB

True	49734
False	107
(Missing)	6

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	49734	99.8%
False	107	0.2%
(Missing)	6	< 0.1%

LAB_NAME
Categorical

HIGH CARDINALITY

Distinct	738
Distinct (%)	1.5%
Missing	116
Missing (%)	0.2%
Memory size	3.5 MiB

EMSL	16737
ENVIRONMENTAL BUILDING SOLUTIONS LLC	7934
EMSL Analytical	4309
Environmental Building Solutions LLC	3586
EBS	3061
Other values (733)	14104

Length

Max length	94
Median length	93
Mean length	17.13478514
Min length	1

Characters and Unicode

Total characters	852130
Distinct characters	73
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	385 ?
Unique (%)	0.8%

Sample

1st row	ENVIRONMENTAL BUILDING SOLUTIONS LLC
2nd row	EMSL
3rd row	Atlas Enviornmental lab corp.
4th row	ENVIRONMENTAL BUILDING SOLUTIONS LLC
5th row	ESML

Common Values

Value	Count	Frequency (%)
EMSL	16737	33.6%
ENVIRONMENTAL BUILDING SOLUTIONS LLC	7934	15.9%
EMSL Analytical	4309	8.6%
Environmental Building Solutions LLC	3586	7.2%
EBS	3061	6.1%
ESML	1905	3.8%
ENVIRONMENTAL BUILDING SOLUTIONS, LLC	1243	2.5%
ebs	1232	2.5%
Environmental Building Solutions, LLC	973	2.0%
Environmental Building	636	1.3%
Other values (728)	8115	16.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
emsl	21600	19.4%
environmental	17394	15.6%
building	16185	14.5%
solutions	15511	13.9%
llc	14725	13.2%
analytical	4874	4.4%
ebs	4301	3.9%
atlas	2012	1.8%
esml	1908	1.7%
lab	1643	1.5%
Other values (347)	11458	10.3%

Most occurring characters

Value	Count	Frequency (%)
L	84486	9.9%
	61896	7.3%
E	55317	6.5%
S	52118	6.1%
N	50379	5.9%
n	44880	5.3%
I	40553	4.8%
i	36529	4.3%
l	34929	4.1%
M	34367	4.0%
Other values (63)	356676	41.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	484408	56.8%
Lowercase Letter	300116	35.2%
Space Separator	61896	7.3%
Other Punctuation	4462	0.5%
Decimal Number	1225	0.1%
Open Punctuation	8	< 0.1%
Close Punctuation	8	< 0.1%
Dash Punctuation	7	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	84486	17.4%
E	55317	11.4%
S	52118	10.8%
N	50379	10.4%
I	40553	8.4%
M	34367	7.1%
O	29706	6.1%
T	21013	4.3%
B	19611	4.0%
A	19443	4.0%
Other values (16)	77415	16.0%

Lowercase Letter

Value	Count	Frequency (%)
n	44880	15.0%
i	36529	12.2%
l	34929	11.6%
o	25298	8.4%
t	24954	8.3%
a	24564	8.2%
e	15972	5.3%
r	13972	4.7%
u	13946	4.6%
s	10810	3.6%
Other values (15)	54262	18.1%

Decimal Number

Value	Count	Frequency (%)
1	609	49.7%
8	231	18.9%
7	190	15.5%
0	92	7.5%
6	45	3.7%
5	17	1.4%
4	17	1.4%
9	12	1.0%
2	10	0.8%
3	2	0.2%

Other Punctuation

Value	Count	Frequency (%)
,	3016	67.6%
.	1192	26.7%
#	139	3.1%
/	81	1.8%
'	15	0.3%
;	10	0.2%
:	6	0.1%
&	3	0.1%

Space Separator

Value	Count	Frequency (%)
	61896	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	8	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	8	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	784524	92.1%
Common	67606	7.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	84486	10.8%
E	55317	7.1%
S	52118	6.6%
N	50379	6.4%
n	44880	5.7%
I	40553	5.2%
i	36529	4.7%
l	34929	4.5%
M	34367	4.4%
O	29706	3.8%
Other values (41)	321260	40.9%

Common

Value	Count	Frequency (%)
	61896	91.6%
,	3016	4.5%
.	1192	1.8%
1	609	0.9%
8	231	0.3%
7	190	0.3%
#	139	0.2%
0	92	0.1%
/	81	0.1%
6	45	0.1%
Other values (12)	115	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	852130	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
L	84486	9.9%
	61896	7.3%
E	55317	6.5%
S	52118	6.1%
N	50379	5.9%
n	44880	5.3%
I	40553	4.8%
i	36529	4.3%
l	34929	4.1%
M	34367	4.0%
Other values (63)	356676	41.9%

NYS_CERTIFIED
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	114
Missing (%)	0.2%
Memory size	2.8 MiB

Y	49630
D	85
N	18

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49733
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Y
2nd row	Y
3rd row	Y
4th row	Y
5th row	Y

Common Values

Value	Count	Frequency (%)
Y	49630	99.6%
D	85	0.2%
N	18	< 0.1%
(Missing)	114	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
y	49630	99.8%
d	85	0.2%
n	18	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
Y	49630	99.8%
D	85	0.2%
N	18	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49733	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
Y	49630	99.8%
D	85	0.2%
N	18	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49733	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
Y	49630	99.8%
D	85	0.2%
N	18	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49733	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
Y	49630	99.8%
D	85	0.2%
N	18	< 0.1%

ANALYTES
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	109
Missing (%)	0.2%
Memory size	2.8 MiB

B	49738

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49738
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	B
2nd row	B
3rd row	B
4th row	B
5th row	B

Common Values

Value	Count	Frequency (%)
B	49738	99.8%
(Missing)	109	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
b	49738	100.0%

Most occurring characters

Value	Count	Frequency (%)
B	49738	100.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49738	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	49738	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49738	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	49738	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49738	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
B	49738	100.0%

COLIFORM
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	135
Missing (%)	0.3%
Memory size	2.8 MiB

A	49697
P	15

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49712
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	49697	99.7%
P	15	< 0.1%
(Missing)	135	0.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
a	49697	> 99.9%
p	15	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	49697	> 99.9%
P	15	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49712	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	49697	> 99.9%
P	15	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49712	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	49697	> 99.9%
P	15	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49712	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	49697	> 99.9%
P	15	< 0.1%

ECOLI
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	135
Missing (%)	0.3%
Memory size	2.8 MiB

A	49694
P	18

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	49712
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	A
2nd row	A
3rd row	A
4th row	A
5th row	A

Common Values

Value	Count	Frequency (%)
A	49694	99.7%
P	18	< 0.1%
(Missing)	135	0.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
a	49694	> 99.9%
p	18	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
A	49694	> 99.9%
P	18	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	49712	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	49694	> 99.9%
P	18	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49712	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	49694	> 99.9%
P	18	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	49712	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	49694	> 99.9%
P	18	< 0.1%

MEET_STANDARDS
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	38723
Missing (%)	77.7%
Memory size	97.5 KiB

True	11113
False	11
(Missing)	38723

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	11113	22.3%
False	11	< 0.1%
(Missing)	38723	77.7%

DELETED
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	48.8 KiB

False	49796
True	51

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	49796	99.9%
True	51	0.1%

LATITUDE
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	5524
Distinct (%)	11.1%
Missing	95
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	40.75580716

Minimum	40.514811
Maximum	40.908632
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.6 KiB

Quantile statistics

Minimum	40.514811
5-th percentile	40.695426
Q1	40.738851
median	40.756105
Q3	40.77524
95-th percentile	40.823477
Maximum	40.908632
Range	0.393821
Interquartile range (IQR)	0.036389

Descriptive statistics

Standard deviation	0.04147346128
Coefficient of variation (CV)	0.001017608635
Kurtosis	4.164851459
Mean	40.75580716
Median Absolute Deviation (MAD)	0.018157
Skewness	-0.4370002353
Sum	2027682.918
Variance	0.00172004799
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
40.764149	115	0.2%
40.703608	100	0.2%
40.757004	90	0.2%
40.768244	80	0.2%
40.713001	79	0.2%
40.748276	71	0.1%
40.710536	70	0.1%
40.707347	69	0.1%
40.65576	59	0.1%
40.754162	59	0.1%
Other values (5514)	48960	98.2%
(Missing)	95	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
40.514811	28	0.1%
40.572169	7	< 0.1%
40.572765	6	< 0.1%
40.572833	9	< 0.1%
40.573621	8	< 0.1%
40.573698	20	< 0.1%
40.573838	6	< 0.1%
40.57448	9	< 0.1%
40.574792	7	< 0.1%
40.574842	2	< 0.1%

Value	Count	Frequency (%)
40.908632	9	< 0.1%
40.907828	9	< 0.1%
40.906656	9	< 0.1%
40.905599	1	< 0.1%
40.904894	5	< 0.1%
40.904756	2	< 0.1%
40.904666	4	< 0.1%
40.903245	5	< 0.1%
40.900321	9	< 0.1%
40.898333	3	< 0.1%

LONGITUDE
Real number (ℝ)

HIGH CORRELATION

Distinct	5456
Distinct (%)	11.0%
Missing	95
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	-73.96932981

Minimum	-74.236572
Maximum	-73.713493
Zeros	0
Zeros (%)	0.0%
Negative	49752
Negative (%)	99.8%
Memory size	389.6 KiB

Quantile statistics

Minimum	-74.236572
5-th percentile	-74.008661
Q1	-73.98934
median	-73.97791
Q3	-73.9618285
95-th percentile	-73.88164
Maximum	-73.713493
Range	0.523079
Interquartile range (IQR)	0.0275115

Descriptive statistics

Standard deviation	0.03852047902
Coefficient of variation (CV)	-0.0005207628503
Kurtosis	9.607390671
Mean	-73.96932981
Median Absolute Deviation (MAD)	0.013229
Skewness	2.265310183
Sum	-3680122.097
Variance	0.001483827304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-73.955251	124	0.2%
-74.009691	100	0.2%
-74.010997	92	0.2%
-73.982526	90	0.2%
-73.982339	80	0.2%
-74.004181	79	0.2%
-74.009378	78	0.2%
-73.98469	71	0.1%
-73.983962	65	0.1%
-73.999235	61	0.1%
Other values (5446)	48912	98.1%
(Missing)	95	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-74.236572	28	0.1%
-74.171256	6	< 0.1%
-74.171244	6	< 0.1%
-74.092492	9	< 0.1%
-74.080729	7	< 0.1%
-74.076584	8	< 0.1%
-74.073261	10	< 0.1%
-74.06448	2	< 0.1%
-74.040648	8	< 0.1%
-74.037377	8	< 0.1%

Value	Count	Frequency (%)
-73.713493	48	0.1%
-73.713627	2	< 0.1%
-73.742187	5	< 0.1%
-73.75121	7	< 0.1%
-73.751235	2	< 0.1%
-73.753179	6	< 0.1%
-73.753204	9	< 0.1%
-73.753454	8	< 0.1%
-73.759283	9	< 0.1%
-73.76903	8	< 0.1%

COMMUNITY_BOARD
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	20
Distinct (%)	< 0.1%
Missing	95
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	5.771124779

Minimum	1
Maximum	81
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	8
95-th percentile	11
Maximum	81
Range	80
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.17385907
Coefficient of variation (CV)	0.5499550247
Kurtosis	131.7677664
Mean	5.771124779
Median Absolute Deviation (MAD)	2
Skewness	5.937725023
Sum	287125
Variance	10.0733814
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
5	12069	24.2%
8	8255	16.6%
6	6034	12.1%
7	5857	11.7%
1	4297	8.6%
2	3950	7.9%
4	3316	6.7%
9	1541	3.1%
3	1115	2.2%
11	1006	2.0%
Other values (10)	2312	4.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4297	8.6%
2	3950	7.9%
3	1115	2.2%
4	3316	6.7%
5	12069	24.2%
6	6034	12.1%
7	5857	11.7%
8	8255	16.6%
9	1541	3.1%
10	621	1.2%

Value	Count	Frequency (%)
81	20	< 0.1%
55	5	< 0.1%
18	8	< 0.1%
17	28	0.1%
16	171	0.3%
15	33	0.1%
14	162	0.3%
13	404	0.8%
12	860	1.7%
11	1006	2.0%

COUNCIL_DISTRICT
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	49
Distinct (%)	0.1%
Missing	95
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	7.222965911

Minimum	1
Maximum	51
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	4
Q3	6
95-th percentile	33
Maximum	51
Range	50
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	9.276344355
Coefficient of variation (CV)	1.284284665
Kurtosis	6.228750238
Mean	7.222965911
Median Absolute Deviation (MAD)	1
Skewness	2.625757536
Sum	359357
Variance	86.05056459
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
4	14895	29.9%
3	7215	14.5%
1	4968	10.0%
6	4927	9.9%
2	4106	8.2%
5	3541	7.1%
7	1314	2.6%
33	1126	2.3%
8	641	1.3%
9	615	1.2%
Other values (39)	6404	12.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4968	10.0%
2	4106	8.2%
3	7215	14.5%
4	14895	29.9%
5	3541	7.1%
6	4927	9.9%
7	1314	2.6%
8	641	1.3%
9	615	1.2%
10	446	0.9%

Value	Count	Frequency (%)
51	28	0.1%
49	48	0.1%
48	178	0.4%
47	190	0.4%
45	22	< 0.1%
44	33	0.1%
43	77	0.2%
42	129	0.3%
41	147	0.3%
40	120	0.2%

CENSUS_TRACT
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	516
Distinct (%)	1.0%
Missing	95
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	3248.012341

Minimum	1
Maximum	155101
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	389.6 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	78
median	122
Q3	195
95-th percentile	16001
Maximum	155101
Range	155100
Interquartile range (IQR)	117

Descriptive statistics

Standard deviation	11467.20125
Coefficient of variation (CV)	3.530528843
Kurtosis	57.31772678
Mean	3248.012341
Median Absolute Deviation (MAD)	53
Skewness	6.573333742
Sum	161595110
Variance	131496704.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	812	1.6%
96	734	1.5%
113	695	1.4%
137	691	1.4%
82	644	1.3%
13	609	1.2%
7	605	1.2%
102	592	1.2%
109	573	1.1%
74	565	1.1%
Other values (506)	43232	86.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	182	0.4%
3	18	< 0.1%
6	51	0.1%
7	605	1.2%
8	108	0.2%
9	812	1.6%
11	153	0.3%
12	48	0.1%
13	609	1.2%
15	145	0.3%

Value	Count	Frequency (%)
155101	50	0.1%
122702	7	< 0.1%
122701	17	< 0.1%
103202	2	< 0.1%
101002	5	< 0.1%
101001	13	< 0.1%
99802	17	< 0.1%
99704	22	< 0.1%
99703	10	< 0.1%
97203	32	0.1%

BBL
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	5235
Distinct (%)	10.5%
Missing	122
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%
Mean	1300742793

Minimum	0
Maximum	5080340045
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	389.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1000800004
Q1	1008410018
median	1012600001
Q3	1015180001
95-th percentile	3061207501
Maximum	5080340045
Range	5080340045
Interquartile range (IQR)	6769983

Descriptive statistics

Standard deviation	766522392.2
Coefficient of variation (CV)	0.5892958978
Kurtosis	5.862141005
Mean	1300742793
Median Absolute Deviation (MAD)	3889933
Skewness	2.636551971
Sum	6.467943539 × 10¹³
Variance	5.875565777 × 10¹⁷
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1014800001	124	0.2%
1000327501	100	0.2%
1000580001	99	0.2%
1012617501	90	0.2%
1007210007	89	0.2%
1016040006	89	0.2%
1010497501	80	0.2%
1001210001	79	0.2%
1002530001	77	0.2%
1008350041	71	0.1%
Other values (5225)	48827	98.0%
(Missing)	122	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	< 0.1%
1000047501	32	0.1%
1000050010	16	< 0.1%
1000057501	22	< 0.1%
1000087501	4	< 0.1%
1000090001	9	< 0.1%
1000090014	19	< 0.1%
1000090029	30	0.1%
1000100014	9	< 0.1%
1000100016	21	< 0.1%

Value	Count	Frequency (%)
5080340045	28	0.1%
5028297501	2	< 0.1%
5012720011	12	< 0.1%
5005900001	9	< 0.1%
5000130008	7	< 0.1%
5000020015	8	< 0.1%
5000017501	10	< 0.1%
4161770055	9	< 0.1%
4161770035	8	< 0.1%
4161770001	9	< 0.1%

NTA
Categorical

HIGH CARDINALITY

Distinct	147
Distinct (%)	0.3%
Missing	95
Missing (%)	0.2%
Memory size	3.8 MiB

Midtown-Midtown South	8275
Upper East Side-Carnegie Hill	4392
Hudson Yards-Chelsea-Flatiron-Union Square	3840
Turtle Bay-East Midtown	3550
Upper West Side	3546
Other values (142)	26149

Length

Max length	53
Median length	42
Mean length	22.87288953
Min length	6

Characters and Unicode

Total characters	1137972
Distinct characters	55
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Turtle Bay-East Midtown
2nd row	Upper East Side-Carnegie Hill
3rd row	East Concourse-Concourse Village
4th row	West Village
5th row	Hunters Point-Sunnyside-West Maspeth

Common Values

Value	Count	Frequency (%)
Midtown-Midtown South	8275	16.6%
Upper East Side-Carnegie Hill	4392	8.8%
Hudson Yards-Chelsea-Flatiron-Union Square	3840	7.7%
Turtle Bay-East Midtown	3550	7.1%
Upper West Side	3546	7.1%
Battery Park City-Lower Manhattan	2747	5.5%
Murray Hill-Kips Bay	2270	4.6%
Lenox Hill-Roosevelt Island	1857	3.7%
Lincoln Square	1820	3.7%
West Village	1730	3.5%
Other values (137)	15725	31.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
south	9288	7.1%
midtown-midtown	8275	6.3%
upper	7938	6.1%
east	6118	4.7%
square	5701	4.4%
hill	5580	4.3%
west	5531	4.2%
side-carnegie	4392	3.4%
side	3882	3.0%
hudson	3840	2.9%
Other values (198)	70297	53.7%

Most occurring characters

Value	Count	Frequency (%)
t	86130	7.6%
e	85913	7.5%
	81090	7.1%
i	79095	7.0%
o	71818	6.3%
a	71225	6.3%
n	70588	6.2%
r	61925	5.4%
l	57316	5.0%
-	45437	4.0%
Other values (45)	427435	37.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	829339	72.9%
Uppercase Letter	182029	16.0%
Space Separator	81090	7.1%
Dash Punctuation	45437	4.0%
Other Punctuation	69	< 0.1%
Open Punctuation	4	< 0.1%
Close Punctuation	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	86130	10.4%
e	85913	10.4%
i	79095	9.5%
o	71818	8.7%
a	71225	8.6%
n	70588	8.5%
r	61925	7.5%
l	57316	6.9%
s	43032	5.2%
d	42315	5.1%
Other values (15)	159982	19.3%

Uppercase Letter

Value	Count	Frequency (%)
M	27699	15.2%
S	26155	14.4%
H	20604	11.3%
C	19287	10.6%
B	13180	7.2%
U	12377	6.8%
E	9860	5.4%
L	8149	4.5%
W	6690	3.7%
T	5201	2.9%
Other values (14)	32827	18.0%

Other Punctuation

Value	Count	Frequency (%)
.	57	82.6%
'	12	17.4%

Space Separator

Value	Count	Frequency (%)
	81090	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	45437	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	4	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	4	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1011368	88.9%
Common	126604	11.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	86130	8.5%
e	85913	8.5%
i	79095	7.8%
o	71818	7.1%
a	71225	7.0%
n	70588	7.0%
r	61925	6.1%
l	57316	5.7%
s	43032	4.3%
d	42315	4.2%
Other values (39)	342011	33.8%

Common

Value	Count	Frequency (%)
	81090	64.1%
-	45437	35.9%
.	57	< 0.1%
'	12	< 0.1%
(	4	< 0.1%
)	4	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1137972	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	86130	7.6%
e	85913	7.5%
	81090	7.1%
i	79095	7.0%
o	71818	6.3%
a	71225	6.3%
n	70588	6.2%
r	61925	5.4%
l	57316	5.0%
-	45437	4.0%
Other values (45)	427435	37.6%

BATCH_DATE
Categorical

HIGH CORRELATION

Distinct	34
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.8 MiB

04/19/2024 12:15:07 PM	1638
04/19/2024 12:15:11 PM	1512
04/19/2024 12:15:22 PM	1512
04/19/2024 12:15:39 PM	1510
04/19/2024 12:15:17 PM	1509
Other values (29)	42166

Length

Max length	22
Median length	22
Mean length	22
Min length	22

Characters and Unicode

Total characters	1096634
Distinct characters	15
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	04/19/2024 12:15:09 PM
2nd row	04/19/2024 12:15:37 PM
3rd row	04/19/2024 12:15:40 PM
4th row	04/19/2024 12:15:09 PM
5th row	04/19/2024 12:15:07 PM

Common Values

Value	Count	Frequency (%)
04/19/2024 12:15:07 PM	1638	3.3%
04/19/2024 12:15:11 PM	1512	3.0%
04/19/2024 12:15:22 PM	1512	3.0%
04/19/2024 12:15:39 PM	1510	3.0%
04/19/2024 12:15:17 PM	1509	3.0%
04/19/2024 12:15:24 PM	1509	3.0%
04/19/2024 12:15:35 PM	1509	3.0%
04/19/2024 12:15:21 PM	1507	3.0%
04/19/2024 12:15:31 PM	1507	3.0%
04/19/2024 12:15:32 PM	1505	3.0%
Other values (24)	34629	69.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
04/19/2024	49847	33.3%
pm	49847	33.3%
12:15:07	1638	1.1%
12:15:11	1512	1.0%
12:15:22	1512	1.0%
12:15:39	1510	1.0%
12:15:17	1509	1.0%
12:15:24	1509	1.0%
12:15:35	1509	1.0%
12:15:31	1507	1.0%
Other values (26)	37641	25.2%

Most occurring characters

Value	Count	Frequency (%)
1	168904	15.4%
2	168821	15.4%
0	109421	10.0%
4	104909	9.6%
/	99694	9.1%
	99694	9.1%
:	99694	9.1%
9	55815	5.1%
5	54359	5.0%
P	49847	4.5%
Other values (5)	85476	7.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	697858	63.6%
Other Punctuation	199388	18.2%
Space Separator	99694	9.1%
Uppercase Letter	99694	9.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	168904	24.2%
2	168821	24.2%
0	109421	15.7%
4	104909	15.0%
9	55815	8.0%
5	54359	7.8%
3	19128	2.7%
7	6052	0.9%
8	5999	0.9%
6	4450	0.6%

Other Punctuation

Value	Count	Frequency (%)
/	99694	50.0%
:	99694	50.0%

Uppercase Letter

Value	Count	Frequency (%)
P	49847	50.0%
M	49847	50.0%

Space Separator

Value	Count	Frequency (%)
	99694	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	996940	90.9%
Latin	99694	9.1%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	168904	16.9%
2	168821	16.9%
0	109421	11.0%
4	104909	10.5%
/	99694	10.0%
	99694	10.0%
:	99694	10.0%
9	55815	5.6%
5	54359	5.5%
3	19128	1.9%
Other values (3)	16501	1.7%

Latin

Value	Count	Frequency (%)
P	49847	50.0%
M	49847	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1096634	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	168904	15.4%
2	168821	15.4%
0	109421	10.0%
4	104909	9.6%
/	99694	9.1%
	99694	9.1%
:	99694	9.1%
9	55815	5.1%
5	54359	5.0%
P	49847	4.5%
Other values (5)	85476	7.8%

Auto

The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	BIN	BOROUGH	ZIP	HOUSE_NUM	STREET_NAME	BLOCK	LOT	CONFIRMATION_NUM	REPORTING_YEAR	TANK_NUM	INSPECTION_BY_FIRM	INSPECTION_PERFORMED	INSPECTION_DATE	GI_REQ_INTERNAL_STRUCTURE	GI_RESULT_INTERNAL_STRUCTURE	GI_REQ_EXTERNAL_STRUCTURE	GI_RESULT_EXTERNAL_STRUCTURE	GI_REQ_OVERFLOW_PIPES	GI_RESULT_OVERFLOW_PIPES	GI_REQ_ACCESS_LADDERS	GI_RESULT_ACCESS_LADDERS	GI_REQ_AIR_VENTS	GI_RESULT_AIR_VENTS	GI_REQ_ROOF_ACCESS	GI_RESULT_ROOF_ACCESS	SI_REQ_SEDIMENT	SI_RESULT_SEDIMENT	SI_REQ_BIOLOGICAL_GROWTH	SI_RESULT_BIOLOGICAL_GROWTH	SI_REQ_DEBRIS_INSECTS	SI_RESULT_DEBRIS_INSECTS	SI_REQ_RODENT_BIRD	SI_RESULT_RODENT_BIRD	SAMPLE_COLLECTED	LAB_NAME	NYS_CERTIFIED	ANALYTES	COLIFORM	ECOLI	MEET_STANDARDS	DELETED	LATITUDE	LONGITUDE	COMMUNITY_BOARD	COUNCIL_DISTRICT	CENSUS_TRACT	BBL	NTA	BATCH_DATE
0	1036156.0	MANHATTAN	10174.0	405	LEXINGTON AVE	1297	23	WTI0794137521	2015	2	ISSEKS BROS INC	Y	08/08/2015	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	ENVIRONMENTAL BUILDING SOLUTIONS LLC	Y	B	A	A	NaN	No	40.751823	-73.975760	6.0	4.0	92.0	1.012970e+09	Turtle Bay-East Midtown	04/19/2024 12:15:09 PM
1	1042461.0	MANHATTAN	10065.0	131	East 66th Street	1401	20	WTI9605598636	2021	1	Rosenwach Tank Co. LLC	Y	10/12/2021	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	EMSL	Y	B	A	A	NaN	No	40.766513	-73.964748	8.0	4.0	120.0	1.014010e+09	Upper East Side-Carnegie Hill	04/19/2024 12:15:37 PM
2	2101266.0	BRONX	10456.0	1118	grand concourse	2462	39	WTI2761355464	2023	1	DCAS	Y	12/19/2023	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	Atlas Enviornmental lab corp.	Y	B	A	A	NaN	No	40.832232	-73.919655	4.0	16.0	18102.0	2.024620e+09	East Concourse-Concourse Village	04/19/2024 12:15:40 PM
3	1009095.0	MANHATTAN	10003.0	28	EAST 10 STREET	561	7502	WTI5921313699	2015	1	ISSEKS BROS INC	Y	01/13/2015	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	ENVIRONMENTAL BUILDING SOLUTIONS LLC	Y	B	A	A	NaN	No	40.732489	-73.993260	2.0	2.0	59.0	1.005618e+09	West Village	04/19/2024 12:15:09 PM
4	4003540.0	QUEENS	11101.0	30-30	47th Avenue	282	1	WTI5300059568	2015	1	Rosenwach Tank Co. LLC	Y	07/18/2015	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	ESML	Y	B	A	A	NaN	No	40.743168	-73.936568	2.0	26.0	199.0	4.002820e+09	Hunters Point-Sunnyside-West Maspeth	04/19/2024 12:15:07 PM
5	1045818.0	MANHATTAN	10021.0	435	EAST 70 STREET	1465	21	WTI6238046041	2018	4	Rosenwach Tank Co. LLC	Y	08/16/2018	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	EMSL	Y	B	A	A	Y	No	40.766129	-73.956066	8.0	5.0	124.0	1.014650e+09	Lenox Hill-Roosevelt Island	04/19/2024 12:15:23 PM
6	1030972.0	MANHATTAN	10023.0	344	WEST 72 STREET	1183	53	WTI6814067879	2021	1	ISSEKS BROS INC	Y	10/12/2021	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	ENVIRONMENTAL BUILDING SOLUTIONS LLC	Y	B	A	A	NaN	No	40.780406	-73.985940	7.0	6.0	159.0	1.011830e+09	Lincoln Square	04/19/2024 12:15:36 PM
7	4534604.0	QUEENS	11109.0	4705	Center Blvd	21	60	WTI8421978672	2018	1	Rockrose Development	Y	11/12/2018	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	Pace Analytical	Y	B	A	A	Y	No	40.745961	-73.956823	2.0	26.0	1.0	4.000210e+09	Hunters Point-Sunnyside-West Maspeth	04/19/2024 12:15:17 PM
8	1079000.0	MANHATTAN	10013.0	100	Centre street	167	1	WTI9798191876	2021	2	DCAS	Y	12/05/2021	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	N	NaN	NaN	NaN	NaN	NaN	NaN	No	40.716084	-74.001425	1.0	1.0	29.0	1.001670e+09	Chinatown	04/19/2024 12:15:34 PM
9	1036079.0	MANHATTAN	10022.0	745	Fifth Ave	1293	69	WTI4076546871	2016	2	Isseks Bros. Inc.	Y	09/17/2016	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	Environmental Building Solutions LLC	Y	B	A	A	NaN	No	40.763326	-73.973695	5.0	4.0	11202.0	1.012930e+09	Midtown-Midtown South	04/19/2024 12:15:10 PM

Last rows

	BIN	BOROUGH	ZIP	HOUSE_NUM	STREET_NAME	BLOCK	LOT	CONFIRMATION_NUM	REPORTING_YEAR	TANK_NUM	INSPECTION_BY_FIRM	INSPECTION_PERFORMED	INSPECTION_DATE	GI_REQ_INTERNAL_STRUCTURE	GI_RESULT_INTERNAL_STRUCTURE	GI_REQ_EXTERNAL_STRUCTURE	GI_RESULT_EXTERNAL_STRUCTURE	GI_REQ_OVERFLOW_PIPES	GI_RESULT_OVERFLOW_PIPES	GI_REQ_ACCESS_LADDERS	GI_RESULT_ACCESS_LADDERS	GI_REQ_AIR_VENTS	GI_RESULT_AIR_VENTS	GI_REQ_ROOF_ACCESS	GI_RESULT_ROOF_ACCESS	SI_REQ_SEDIMENT	SI_RESULT_SEDIMENT	SI_REQ_BIOLOGICAL_GROWTH	SI_RESULT_BIOLOGICAL_GROWTH	SI_REQ_DEBRIS_INSECTS	SI_RESULT_DEBRIS_INSECTS	SI_REQ_RODENT_BIRD	SI_RESULT_RODENT_BIRD	SAMPLE_COLLECTED	LAB_NAME	NYS_CERTIFIED	ANALYTES	COLIFORM	ECOLI	MEET_STANDARDS	DELETED	LATITUDE	LONGITUDE	COMMUNITY_BOARD	COUNCIL_DISTRICT	CENSUS_TRACT	BBL	NTA	BATCH_DATE
49837	1039577.0	MANHATTAN	10022.0	926	2 AVENUE	1342	7502	WTI8256422799	2015	1	ISSEKS BROS INC	Y	10/07/2015	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	ENVIRONMENTAL BUILDING SOLUTIONS LLC	Y	B	A	A	NaN	No	40.754391	-73.968865	6.0	4.0	98.0	1.013428e+09	Turtle Bay-East Midtown	04/19/2024 12:15:11 PM
49838	1050288.0	MANHATTAN	10128.0	345	EAST 93 STREET	1556	23	WTI6547790034	2019	1	Rosenwach Tank Co. LLC	Y	08/13/2019	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	EMSL	Y	B	A	A	Y	No	40.781501	-73.946545	8.0	5.0	154.0	1.015560e+09	Yorkville	04/19/2024 12:15:19 PM
49839	1013561.0	MANHATTAN	10001.0	481	8th Avenue	758	37	WTI9666566390	2015	4	NALCO	Y	12/16/2015	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	A	Y	N	Y	N	Y	N	Y	Environmental Building Solutions	Y	B	A	A	NaN	No	40.752295	-73.993402	4.0	3.0	111.0	1.007580e+09	Hudson Yards-Chelsea-Flatiron-Union Square	04/19/2024 12:15:08 PM
49840	1023161.0	MANHATTAN	10019.0	1301	Sixth Avenue	1005	29	WTI7141946796	2021	1	Rosenwach Tank Co. LLC	Y	05/21/2021	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	EMSL	Y	B	A	A	NaN	No	40.761244	-73.979457	5.0	4.0	131.0	1.010050e+09	Midtown-Midtown South	04/19/2024 12:15:20 PM
49841	1038755.0	MANHATTAN	10017.0	307	EAST 44TH STREET	1337	6	WTI6051431041	2024	1	ISSEKS BROS., INC.	Y	01/10/2024	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	ENVIRONMENTAL BUILDING SOLUTIONS, LLC	Y	B	A	A	NaN	No	40.750949	-73.970841	6.0	4.0	90.0	1.013370e+09	Turtle Bay-East Midtown	04/19/2024 12:15:38 PM
49842	1046609.0	MANHATTAN	10028.0	993	Fifth Avenue	1492	3	WTI1912305134	2016	1	Isseks Bros Inc	Y	06/02/2016	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	Environmental Building Solutions LLC	Y	B	A	A	NaN	No	40.777917	-73.963041	8.0	4.0	142.0	NaN	Upper East Side-Carnegie Hill	04/19/2024 12:15:11 PM
49843	1015240.0	MANHATTAN	10018.0	1359	BROADWAY	812	22	WTI8209022370	2018	1	Rosenwach Tank Co. LLC	Y	03/24/2018	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	EMSL	Y	B	A	A	Y	No	40.751704	-73.987599	5.0	3.0	109.0	1.008120e+09	Midtown-Midtown South	04/19/2024 12:15:18 PM
49844	1016080.0	MANHATTAN	10003.0	85	5 AVENUE	844	1	WTI2121287041	2019	1	Rosenwach Tank Co. LLC	Y	11/23/2019	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	EMSL Analytical	Y	B	A	A	Y	No	40.737416	-73.992581	5.0	2.0	52.0	1.008440e+09	Hudson Yards-Chelsea-Flatiron-Union Square	04/19/2024 12:15:25 PM
49845	4433878.0	QUEENS	11375.0	70-25	YELLOWSTONE BOULEVARD	3236	35	WTI0442120892	2017	1	Rosenwach Tank Co. LLC	Y	05/04/2017	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	EMSL	Y	B	A	A	Y	No	40.722598	-73.849816	6.0	29.0	711.0	4.032360e+09	Forest Hills	04/19/2024 12:15:09 PM
49846	1040043.0	MANHATTAN	10022.0	339	East 58th Street	1351	17	WTI1724049027	2015	1	Rosenwach Tank Co. LLC	Y	04/11/2015	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	N	Y	ESML	Y	B	A	A	NaN	No	40.759440	-73.963488	6.0	5.0	108.0	1.013510e+09	Turtle Bay-East Midtown	04/19/2024 12:15:09 PM

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Uppercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Math Symbol

Dash Punctuation

Open Punctuation

Most occurring scripts

Most frequent character per script